| Column | Data Type | Nullable | Default | Description |
| DEPARTMENT_ID | NUMBER(4, 0) | not null | | Primary key column of departments table. |
| DEPARTMENT_NAME | VARCHAR2(30) | not null | | A not null column that shows name of a department. Administration, |
| MANAGER_ID | NUMBER(6, 0) | null | | Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column. |
| LOCATION_ID | NUMBER(4, 0) | null | | Location id where a department is located. Foreign key to location_id column of locations table. |